<?php
$page_title="Manage Member Queries / Suggestions - List";
	include("includes/header.php");
?>
<?
$query="select p.*,q.* from bkitc_queries q JOIN bkitc_profiles p on  q.member_id=p.registrant_id where q.rec_status>=1 ";
$queryInfo = qry_data($query." order by rec_created desc");

?>

		<div class="cleardiv">
		
		</div>
<table width="100%" >
	<tr>
	<td valign="top">
		
	<table   class="table_panel" width="100%"  cellspacing="0" cellpadding="4">
	<tr  align="left">
	<th width="5">S.No</th>
	<th  style="width:120px">Member</th>
	<th>Mobile</th>
	<th>Email</th>
	<th>Submitted  </th>
	<th>Query Type</th>
	<th>View </th>
	</tr>
	<? foreach($queryInfo as $i=>$query) {?>

	<tr <?if($i%2==0) echo 'class="white_bg"'; else echo 'class="grey_bg"' ?>>
	<td><?=$i+1;?></td>
	<td ><?=$query["full_name"];?></td>
	<td ><?=$query["mobile_no"];?></td>
	<td ><?=$query["email_id"];?></td>
	<td ><?=$query["rec_created"];?></td>
	<td><?=$query_types[(int)$query["query_type"]]?></td>
	
	<td>
		<a href="edit_query.php?mode=edit&query_id=<?=$query["query_id"];?>">View</a> 
		<a style="display:none" href="javascript:if(confirm('Are you sure to delete this record?')) location.href='edit_query.php?mode=del&query_id=<?=$query["query_id"];?>'";>Delete</a> 
	</td>
	</tr>
	
	<? } ?>
	</table>
	
	</td>
	</tr>
	
	</table>

<?php include("includes/footer.php"); ?>

